﻿create table dbo.Customer
(
	FirstName nvarchar,
	LastName nvarchar,
	StreetAddress nvarchar,
	City nvarchar,
	State nvarchar,
	PostalCode nvarchar,
	Id int not null identity,
	Email nvarchar);
create table dbo.Product
(
	Name nvarchar,
	Price nvarchar,
	Id int not null identity);
create table dbo.Order
(
	Date nvarchar,
	TotalAmount money,
	Id int not null identity,
	CustomerId int);
create table dbo.OrderItem
(
	Id int not null identity,
	OrderId int,
	ProductId int);
create table dbo.IBuySpy
(
);
